Quiz: Marks & Filters I

Tasks to complete:

Task List:

Assure you are working with a clean Sheet.

Drag Profit to Rows and Region to Columns.

Quiz 1 below.

Drag Order Date into the Filters menu.

Select Years then all years in the pop up menu. Then hit OK.

Select the drop down on the YEAR(Order Date) within the Filters table and select Show Filter.

Select Sort from the top Menu.

Add Category to both the Marks table (as a color) and to the Filters table.

Select the drop down on the Category within the Filters table and select Show Filter.

Quiz 2 below.

Drag the Sales to the Detail portion of the Marks table.

Quiz 3 below.

Name this BarChart1, and open a new sheet in the bottom left hand corner. You should see Sheet 2 appear.

Nice job! You are becoming a Tableau Pro! Being comfortable with the Filters and Marks tables creates a very valuable skill set!

SOLUTION:

Central

QUIZ QUESTION::

Use the bar chart with filters to match each description to the appropriate Region.

ANSWER CHOICES:

Description	Region
The only Region with negative Profit in 2014. It was associated with Furniture.
This Region had the second highest Profit for Furniture in 2012.
This Region had the second highest Profit for Office Supplies in 2012.
This Region had the lowest Profit across all years when looking at the combination of Office Supplies and Technology sales.

SOLUTION:

Description	Region
This Region had the second highest Profit for Furniture in 2012.
This Region had the second highest Profit for Office Supplies in 2012.
This Region had the lowest Profit across all years when looking at the combination of Office Supplies and Technology sales.
The only Region with negative Profit in 2014. It was associated with Furniture.

SOLUTION: